﻿CREATE VIEW [dbo].[vwServerWaitingList]
AS

SELECT		ROW_NUMBER() OVER(PARTITION BY srv_type_ro, srv_version_major_ro ORDER BY srv_type_ro, srv_version_major_ro, srv_server_name) rownum,
			srv_type_ro,
			srv_edition_ro,
			srv_server_name,
			srv_description,
			srv_product_version,
			srv_has_local_jobs,
			srv_has_master_jobs,
			srv_is_mixed_mode,
			srv_backup_directory,
			srv_version_major_ro,
			srv_version_minor_ro
FROM		dbo.tblServer
WHERE		srv_is_disabled = 0
			AND srv_is_active = 0
			AND srv_is_vendor_managed_ro = 0
